The Stocktake program in MDS allows users to update stock volumes within a batch of selected items. The relevant items are specified and each one can be updated, amended or appended depending upon the method chosen. Micronet values the items added or written off at the average or standard cost and transfers these amounts from Stock on Hand in the Balance Sheet to the Cost of Sales section of the Profit & Loss.
For example, say the average cost of an item is $10.00. There are 10 items on hand in Micronet, but the physical stocktake at the end of financial year shows that only eight items are actually on hand. Stock is valued at $100.00. Upon creating the stocktake batch, you have set the stocktake method to Overwrite SOH with Stocktake Qty. In processing the amendment, the user updates the stock to 8 units. At the time of posting, Micronet generates the following entries for the General Ledger:
Debit | 117 | Stocktake Adjustments | $ 20.00 | Increase Cost of Sales Average Cost |
Credit | 115 | Stock on Hand | $ 20.00 | Decrease Current Assets Average Cost |